﻿using BwTMusicModels;
using HwjUIDI.Utility.DatabaseHelper;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BwTMusicServices.Theme
{
    public class ThemeServices
    {
        public  List<North_Theme> GetThemeList()
        {
            List<North_Theme> themes = new List<North_Theme>();
            try
            {
                string sql = "select * from North_Theme";
                using (SqlDataReader dr = DatabaseFactory.GetDatabase().ExecuteDataReaderSQL(sql))
                {
                    while (dr.Read())
                    {
                        North_Theme theme = new North_Theme();
                        theme = new ModelsHelper().GetNorthThemeModels(dr);
                        themes.Add(theme);
                    }
                }
            }
            catch (Exception)
            {

            }

            return themes;

        }
    }
}
